<?php

class SinglepageController extends Zend_Controller_Action
{

    public function init()
    {
        /* Initialize action controller here */
    }

    public function indexAction()
    {
        // action body
    }

    public function xiuYanYuAction()
    {
        //设置title
		$this->view->headTitle("岫岩玉");
		//设置关键词（seo）
		$this->view->headMeta()->appendName('keywords', '岫岩玉,岫玉,河磨玉,黄白老玉');
		//设置描述（seo）
		$this->view->headMeta()->appendName('description','岫岩玉因主产于辽宁岫岩而得名，是我国的四大名玉之一。主要出产的品种有蛇纹石岫玉及透闪石类的河磨玉和老玉，岫岩玉以产量大和体量大而著称。世界上最大的玉佛既有岫岩花玉雕刻而成。');
    }

    public function jingDianXiuYuDiaoKeZuoPinJianShangAction()
    {
        //设置title
		$this->view->headTitle("经典岫玉雕刻作品鉴赏");
		//设置关键词（seo）
		$this->view->headMeta()->appendName('keywords', '岫岩玉图片鉴赏,岫岩玉摆件图片,玉雕图片');
		//设置描述（seo）
		$this->view->headMeta()->appendName('description','经典岫岩玉雕刻作品图片鉴赏，包含人物、动物、花卉、山水、瓶素五大系列，近百张精美的岫岩玉雕摆件图片。');
        
        $config=new Zend_Config_Ini(APPLICATION_PATH."/configs/application.ini",'production');
		$db = Zend_Db::factory($config->resources->db);
        $selecter=$db->select()->from('txy_gallery',array('gallery_id','gallery_title','gallery_url_spell','gallery_logo'))
		->where('gallery_id <=22 and gallery_flag=1')
		->order('gallery_id asc');
		$galleryrlist=$db->fetchAll($selecter);
		$this->view->galleryr=$galleryrlist;
		
		$selected=$db->select()->from('txy_gallery',array('gallery_id','gallery_title','gallery_url_spell','gallery_logo'))
		->where('gallery_id >22 and gallery_id<=54 and gallery_flag=1')
		->order('gallery_id asc');
		$gallerydlist=$db->fetchAll($selected);
		$this->view->galleryd=$gallerydlist;
		
	    $selecteh=$db->select()->from('txy_gallery',array('gallery_id','gallery_title','gallery_url_spell','gallery_logo'))
		->where('gallery_id >54 and gallery_id<=74 and gallery_flag=1')
		->order('gallery_id asc');
		$galleryhlist=$db->fetchAll($selecteh);
		$this->view->galleryh=$galleryhlist;
		
		$selectes=$db->select()->from('txy_gallery',array('gallery_id','gallery_title','gallery_url_spell','gallery_logo'))
		->where('gallery_id >74 and gallery_id<=80 and gallery_flag=1')
		->order('gallery_id asc');
		$galleryslist=$db->fetchAll($selectes);
		$this->view->gallerys=$galleryslist;
		
		$selectep=$db->select()->from('txy_gallery',array('gallery_id','gallery_title','gallery_url_spell','gallery_logo'))
		->where('gallery_id >80 and gallery_id<=90 and gallery_flag=1')
		->order('gallery_id asc');
		$galleryplist=$db->fetchAll($selectep);
		$this->view->galleryp=$galleryplist;
		
		$selecten=$db->select()->from('txy_gallery',array('gallery_id','gallery_title','gallery_url_spell','gallery_logo'))
		->where('gallery_id >=91 and gallery_flag=1')
		->order('gallery_id desc');
		$gallerynlist=$db->fetchAll($selecten);
		$this->view->galleryn=$gallerynlist;
    }

    public function yuDiaoTuAnYuYiAction()
    {
        //设置title
		$this->view->headTitle("玉雕图案及寓意专题");
		//设置关键词（seo）
		$this->view->headMeta()->appendName('keywords', '玉饰品,玉雕纹饰,玉雕图案,玉雕寓意');
		//设置描述（seo）
		$this->view->headMeta()->appendName('description','本专题主要介绍常见的玉饰品，如平安扣、手镯、如意等的说道及相关文化，以及我国传统玉雕造型或玉雕图案的一些寓意及含义。');
    }

    public function yuShiZhiShiJianMingWenDaAction()
    {
        //设置title
		$this->view->headTitle("珠宝玉石简明知识问答专题");
		//设置关键词（seo）
		$this->view->headMeta()->appendName('keywords', '玉石知识,玉的常识,珠宝知识,简明问答');
		//设置描述（seo）
		$this->view->headMeta()->appendName('description','本专题已尽量简单明了的方式来说明或介绍一些基础的珠宝玉石知识和玉石的常识。');
		$config=new Zend_Config_Ini(APPLICATION_PATH."/configs/application.ini",'production');
		$db = Zend_Db::factory($config->resources->db);
        $select=$db->select()->from('txy_article',array('article_id','article_url_spell','article_title'))
    		   ->where('article_id>=65 and article_id<=84 or article_id in(58,107,124,125,127,182)');
    	$res=$db->fetchAll($select);
    	$this->view->res=$res;    		   
    }


}







